package com.scores.mapper;


import com.scores.pojo.Score;
import com.scores.pojo.ThreeS;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface ScoreMapper {

    int getScoreCount(@Param("studentName") String name);

    List<ThreeS> getAllScoresByPage(@Param("studentName") String name, @Param("page") Integer page, @Param("pageSize") Integer size);

    int updateScore(@Param("s") ThreeS threeS);

    int addScore(@Param("s") Score score);

    int deleteScore(@Param("scoreId") Integer scoreId);

    int deleteByStudentIdInt(@Param("studentNo") Integer studentNo);

    List<ThreeS> getTotalScore();

    List<ThreeS> getScoreByStudentNo(@Param("studentNo") Integer studentNo, @Param("page") Integer page, @Param("pageSize") Integer limit);

    List<Score> getScoreBySubjectId(@Param("subjectId") Integer subjectId);

    List<Score> getScoreByStnoAndSuid(@Param("studentNo") Integer studentNo, @Param("subjectId") Integer subjectId);
}
